select * from products where pro_name like '%Spring%dresses%' or pro_des like '%Spring%dresses%'union all select * from products where (pro_name like '%Spring%' or pro_des like '%Spring%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Spring%dresses%' or pro_des not like '%Spring%dresses%')
Great Halter Top Sleeveless Little Girl Pageant Dress Floor Length Beading and Ruffles Taffeta
Halter Top Purple Taffeta Zipper Pageant Dress for Teens Sleeveless Floor Length Beading
Ball Gowns Pageant Gowns For Girls Royal Blue Halter Top Taffeta Sleeveless Floor Length Zipper
Halter Top Floor Length Ball Gowns Sleeveless Turquoise Pageant Dress for Womens Zipper
Scoop Floor Length Zipper Child Pageant Dress Pink for Party and Wedding Party with Beading
High Quality Organza Sleeveless Floor Length Pageant Gowns and Beading
Scoop Turquoise Ball Gowns Beading Little Girls Pageant Gowns Zipper Organza Sleeveless Floor Length
Scoop Beading Little Girls Pageant Dress Green Zipper Sleeveless Floor Length
Scoop Beading Girls Pageant Dresses Pink Zipper Sleeveless Floor Length
Fantastic Blue Zipper Spaghetti Straps Beading and Sequins Child Pageant Dress Tulle Sleeveless
Customized Light Blue Sleeveless Floor Length Beading and Sequins Zipper Girls Pageant Dresses
Pretty Brown Straps Neckline Beading and Belt Winning Pageant Gowns Sleeveless Lace Up
Tulle Straps Sleeveless Lace Up Belt Kids Pageant Dress in Purple
Purple Straps Neckline Beading and Belt Kids Pageant Dress Sleeveless Lace Up
Superior Sleeveless Lace Up Floor Length Beading and Belt Pageant Dress
Floor Length Ball Gowns Sleeveless Teal Pageant Dress for Teens Lace Up